package com.comum.javahomework420242025.repository;

import com.comum.javahomework420242025.pojo.QuoteAndProductionPS;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface QuoteAndPSRepository extends JpaRepository<QuoteAndProductionPS,Long> {
    @Query("select qps from quoteandproductionps qps where " +
            "qps.departmentproductionid=:id")
    List<QuoteAndProductionPS> findBydpid(String id);
    @Query("select qps from quoteandproductionps qps where " +
            "qps.quoteid=:id")
    List<QuoteAndProductionPS> findByQuoteId(String id);
}
